🕷️️ Job Radar • SCRAPING

upwork.com 🟡 2026-05-14

🔹 [Target] Extract price data point and graph image from CNBC webpage [Method] Python script [UI/UX] N/A [Stack] Python, BeautifulSoup, requests, matplotlib, SQLAlchemy [Security] N/A [Format] JSON
👤 Client: 🇨🇦 Canada Member since 2013-12-23
💰 Price: ****
🚩 Problem: Automate the extraction of financial data and visualizations from a public website into a local database for historical analysis.
📦 Existing: Not specified

Specifications:

[Target] Extract price data point and graph image from CNBC webpage
[Method] Python script using BeautifulSoup for HTML parsing, requests for HTTP requests, matplotlib for graph image extraction, SQLAlchemy for database interaction
[UI/UX] N/A
[Stack] Python, BeautifulSoup, requests, matplotlib, SQLAlchemy
[Security] No specific security measures required
[Format] JSON

Workflow:

1. Use BeautifulSoup to parse the HTML content of the CNBC webpage.
2. Extract the price data point and locate the graph element.
3. Use requests to fetch the graph image URL.
4. Convert the graph image to a static format (e.g., PNG) using matplotlib.
5. Connect to the locally hosted MariaDB instance using SQLAlchemy.
6. Insert the extracted price data point and graph image into the database with timestamped records.
7. Write a SQL query to extract the data point and image for a specific date and time range to a local PC folder.